chinni1 0 Newbie Poster
SELECT * INTO [supplierexp] FROM [supplier] IN '' [ODBC;Driver={SQLServer};Server=(local);Database=sh op;user name='shop';password='abc123';Trusted_ Connection=yes];"

For above code im getting error like ODBC--connection to '{SQLServer}(local)' failed.Im using the valid username and password only

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.