Failed Local connection but remote connection OK.
Hi I can connect to a remote SQL Express server using the connection string
strconnectionStringX = "Data Source=192.168.1.67; Provider=SQLNCLI11; DataTypeCompatibility=80; Network Library=DBMSSOCN; Initial Catalog=vocab; User ID=[ID]; Password=[Password]"
But Not a local server instance. Any ideas? No problem connecting to the local server using SSMS.
Oracle OLE DB - Connection string without password
Hello, I'm working on programmatic queries relying on the Oracle provider for OLE DB (in VB script). I can successfully query my database using the standard syntax: Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;0 votes0 answersAlexis Preel1 day ago
ASP connection to .xls
I am trying to insert excel data into an access database. The code below works perfectly for me even though it gives me access denied after successful upload. <% Set cn = CreateObject("ADODB.Connection")0 votes0 answersWisdom Deku3 days ago
database error exception
hello....i have mysql database connectivity error in C#.net...0 votes0 answersPriyanka Vaskar6 days ago
Excel 2010 vba loses system DSN connection
I have been successfully using the following PostgreSQL connection string in multiple Excel 2010 vba applications running on 64 bit Windows 7 systems. I have moved to a Window 10 system and my application will randomly lose it's connection to the DSN.0 votes0 answersSteven Haley2 weeks ago
Any one Write My Essay For Me UK For My Academic Field.
How do i change my profile picture? Write My Essay For Me UK0 votes0 answersMichael David1 month ago
Failing to connect with ADO.
Connecting using ADO in VBA / Excel. I've done the ado stuff before .... 5 years ago so I'm a bit rusty. Installed MySQL on my laptop and trying to work with DBases again.0 votes0 answersBarry Pettis1 month ago
Hello there, I am newbie here
Hello there! I am newbie here and i want to get complete my college assignment, so please tell me any tutor for it. My assignment is based on online nursing assignment help. http://www.researchmyassignment.com/0 votes2 answersEva Wilson1 month ago
Why study in Australia?
Choosing to think about in Australia secures you an internationally perceived training, access to world-class offices, and critical understudy experiences.Moving over the world to contemplate is an important choice – how would you pick where to go?0 votes1 answermaria alex2 months ago
cant connect to sql via ip
Data Source=220.127.116.11,1433;Network Library=DBMSSOCN; Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword; i configuered the connection ok and from my laptop-1 i connect to sql server and success0 votes0 answersyasir sam2 months ago
- Load more posts