What is the string connection that i need to connect
Good morning, I'm new here, live in Venezuela, glad to know about you, come here to solve a problem with a connection between a Visual Basic 6, and Sql Server 2000, converted my Access database to Sql database with Access, .adp, and move to Sql server 2000 with access2003. Sorry if i am beginning with sql server 2000 my first sql Server.
My dababase name is Consultorio_OdontologicoSQL.MDF, is beside Master, Northwind, pubs, ...
Move from Access to Sql Server 2000, with and export to Sql Server from Access.
OS is Windows Xp profesional, work from down to up, scalable work.
The mayor problem is stablish the connection string, allways an error in the connection, well please need someone that can help me.
My atempts to connect are those;
GlobalCn="Provider=SQLOLEDB; " & _
"Initial Catalog=Consultorio_Odontologico.MDF; " & _
"Data Source=COMP1; " & _
"Integrated Security SSPI; " & _
"Trusted Connections=True; " & _
"User=Usuario1; " & _
this, and combinations but all fail.
ON SERVER: (COMP1)
- With windows connectios
- Session begin: COMP1\Usuario1
on server tried windows, Windows and Sql Server
errors can be on string needed or configuration server.
Hope someone can help me on it. Thanks.
Assist with AHK to send / receive queries to MSAccess
Has or does anybody have information about working in "AHK" "Auto Hotkey" and connecting to an access database? Have found this link: https://github.com/IsNull/ahkDBA0 votes0 answersBarry Pettis5 days ago
connections not work in php
I am trying to connect an access 97 database from php, I have tried three ways methods and none works for me: $db = 'c:/VENTAS.MDB'; $odbcname = "ventas_dsn_sistema";0 votes0 answerscarlos col1 month ago
Azure SQL DB connection string is not working unless logged in to azure account
I'm building an Visual C++ project which is connected to Azure SQL database via ODBC, I placed the following connection string that Azure:0 votes0 answersAhmed Ayman1 month ago
Making Constant Data Bases to recall in program.
I'm a student learning programming. I need to find out what web address gets my database and server. I need to find out what the database name is.0 votes0 answersBrad Harris1 month ago
Connection error IIS10/SQL 2016
I try to transfer a classic-asp-application from Windows Server 2008R2/II7 to 2016/II10 and SQL 2008 to SQL 2016. The application works fine with IIS10 and SQL 2008. Also with IIS7 and SQL 2016.0 votes0 answersPaul H. Niederbracht1 month ago
SSIS package with ODBC source Teradata Deployment issue
SSIS package works fine in Visual Studio, But when deployed it says gives error, SQL Jobs fails execution0 votes0 answersSandesh J2 months ago
Connect to SQl with gMSA
I'm trying to make use of gMSA's to connect from ASP/X code to an MS SQL 2016 server. I've configured the gMSA with permissions on the target database and set up the gMSA on the source server, but can't get a connection string configured to use the account.0 votes0 answersSteve Sirag3 months ago
Connection String Not Working
I am new to SQL Connection strings. We recently migrated from SQL Server 2008 32 bit to SQL Server 2017 64 bit. The database I am using is an Access 2010 32 bit and we upgraded to Access 2013 32 bit. I believe the connection string that was being used for SQL Server 2008 32 bit was0 votes0 answersTheresa Draper3 months ago
Need connection string for Office 2019
I wrote a VB .NET program using VS17 that opens Excel files and loads the data into an Access database. For .xls files, I use the connection string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source= ...;Extended Properties Excel 8.0;1 vote2 answersMark Cykowski5 months ago
Macro ne fonctionnent pas avec le runtime access
Bonjour et merci voici mon besoin j'ai un fichier excel qui me permet de gere mes contact depuis un userform dans le quel il y a des textbox et une combobox qui a pour base une table access0 votes0 answersM'chi5 months ago
- Load more posts